package com.liu.bookshop.book;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.liu.bookshop.entities.Sell;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;
import java.util.Map;

@Mapper
public interface SellMapper extends BaseMapper<Sell> {
    @Select("select * from sell s,user u,book b where s.book = b.id and s.user = u.username")
    List<Map<String,Object>> getSell();
}
